Return Vendor name if selected

Closed

hello_sarah - Dec 23, 2009 at 07:46 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 23, 2009 at 09:04 PM

Hello, I am creating a purchasing form and want to insert the Vendor name when an item is checked off in the next column.

Example.
A B
Bob's Store x
Amazon.com
Mark's Pizza x

If B=X I want the cell to return Bob's Store and Mark's Pizza
I am not sure what this is called and can only find examples that use a #

THANK YOU

Return Vendor name if selected
Zuma return - Download - Puzzle
How to take screenshot of selected area in excel - Guide
If cell contains date then return value - Excel Forum
Clear only the formatting from the selected cell (leaving the content) - Guide
Display two columns in data validation list but return only one - Guide

1 response

Answer 1 / 1

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 23, 2009 at 09:04 PM

you have to explain what you mean by "cell to return". where do you want (same sheet or another sheet) and in which format.
give an example of result you want

I presume that you are thinking of some thing like "vlookup" or "index-match"

Similar discussions

WOW equipment return

If a cell contains any text then add a value

If cell = date return yes or no.

Excel: If Date =, then enter a value

Excel "IF" function w/ date in test cell

Similar discussions

Subscribe To Our Newsletter!