# LOOKUP Formula

#### marshak

##### Board Regular
Good evening,

I'm having trouble coming up with this formula which would make my life a lot easier .

There are 2 spreadsheets that I basically need to compare and return a value.

If value in Column C (found in Spreadsheet 2) matches the value in Column B (Spreadsheet 1), then I need the value that is in Column F of Spreadsheet 1 placed into Column S of Spreadsheet 2.

Please let me know if I'm not being clear.

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

#### Michael M

##### Well-known Member
This....in S1 of Sheet2, and copy down

Code:
``=IF(C1=Sheet1!B1,Sheet1!F1,"")``

#### marshak

##### Board Regular

What I realized when using the solutions is that I need to lookup the entire column.

For example, I need to look up the name from Column C (in Sheet2), see if it is in Column B of Sheet 1, then if there is a value in Column F of Sheet 1, place that value into Column S of Sheet 2

I know it's confusing, but please let me know of any questions.

Thanks!!

#### Tetra201

##### MrExcel MVP
Try putting the following formula in cell S2 of Sheet 2:

=VLOOKUP(C2,'Sheet 1'!B:F,5,0)

#### marshak

##### Board Regular
You are awesome!! That worked!

Thanks a bunch!

You are welcome.

#### DataMike

##### New Member
If you need to stay within Excel, you should be able to use some variation of the VLOOKUP function for that.

However, if this is something you have to do often, check out Parabola (https://parabola.io/). You can use a drag/drop to set up your steps and run them automatically without needing any formulas. You basically just need a "Join" and a "Column Filter". Disclaimer: I'm a founder.

Replies
7
Views
381
Replies
9
Views
211
Replies
1
Views
152
Replies
7
Views
296
Replies
13
Views
623

1,191,036
Messages
5,984,273
Members
439,881
Latest member
Amitoj95

### 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.

### Which adblocker are you using?

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

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