LOOKUP Formula

[marshak]

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.

Thanks so much in advance for your help!!

 

[Michael M]

This....in S1 of Sheet2, and copy down

=IF(C1=Sheet1!B1,Sheet1!F1,"")

 

[marshak]

Thanks so much for your reply.

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]

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

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

 

[marshak]

You are awesome!! That worked!

Thanks a bunch!

 

[Tetra201]

You are welcome.

 

[DataMike]

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.