In Excel or OpenOffice calc I have
 Foo  Bar 
+++
 A  1 
 B  2 
Is it possible to use VLOOKUP
to search a value in the Bar column and return the value in the Foo column?
In Excel or OpenOffice calc I have
Is it possible to use 

add comment 
Try this solution:
This chooses a specific cell out of a matrix.
"Foo" would be in column A, "Bar" would be column B. 


VLOOKUP
can only use the left hand column. – AndrewC Sep 28 '12 at 5:58