Return Vendor name if selected

Closed
hello_sarah - 23 Dec 2009 à 19:46
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 23 Dec 2009 à 21:04
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

1 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
23 Dec 2009 à 21:04
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"