Lookup question

If I have the following table:

LOCATION CAT DESC WID DEP POS HGT POS HGT X Y Z
@0420001 R TP 48 40 0 0 *** 288 13393 21603 0
@0540001 R TP 48 40 0 0 *** 288 11633 10218 0
@0620001 R TP 48 40 0 0 *** 288 14432 21603 0
@0620002 R TP 48 40 0 0 *** 288 14432 21603 0
@0870001 R TP 48 40 0 0 *** 288 14425 10218 0
@1370004 R TP 48 40 0 0 *** 288 15140 10218 0
@1540003 R TP 48 40 0 0 *** 288 13330 10218 0
@1620001 R TP 48 40 0 0 *** 288 15532 10218 0
@1820005 R TP 48 40 0 0 *** 288 11991 10218 0
@2140010 R TP 48 40 0 0 *** 288 12590 10218 0
@2750001 R TP 48 40 0 0 *** 288 12590 10218 0
@2850001 R TP 48 40 0 0 *** 288 16659 10218 0


I have a separate table that needs to display the value in column A (Location) if column B is displayed as "R". vlookup would work but it only references the first column?!