Return Vendor name if selected

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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"