HELP WITH VLOOKUP (I think?) FORMULA

[BruceEdwards]

I have a data table and I need to insert some values in a couple columns based on data in some of the other columns.

For example:

In F1, I have a value of XXX. In this column there could be many unique values. For each of them, there is data in a table which I need to lookup and get, and place in column G.

So the logic goes like this, if F1 contains the value XXX, go to a table, where the corresponding data is, find XXX, move over a column, and put that value in G1.

I think this can be done with VLOOKUP, but I don't know how to do it.

Thanks in advance for all your help!!

 

[tactps]

=vlookup(F1,table_reference,2,false)

So if your table was in cells A1:D40
=vlookup(F1,$a$1:$d$40,2,false)

 

[Artemus]

The following formula assumes the the value you want to look up (XXX) is in cell A1 and that E1:F3 is the table containing the list of items to compare to (column E) and the values you want returned (column F). This also assumes that you want an exact match. It doesn't matter if the values in column E are sorted, but the must be unique.

The formula would be slightly different if you don't require an exact match.

=VLOOKUP(A1,E1:F3,2,FALSE)