HELP WITH VLOOKUP (I think?) FORMULA

BruceEdwards

Board Regular
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!!

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
=vlookup(F1,table_reference,2,false)

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

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)

Replies
3
Views
315
Replies
6
Views
230
Replies
4
Views
152
Replies
9
Views
159
Replies
1
Views
196

1,207,096
Messages
6,076,554
Members
446,213
Latest member
bettigb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back