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

1 response

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"
0