HELP. I need a calculation

gawly

New Member
Joined
Feb 7, 2006
Messages
15
I'm new to Excel and I need to right a calculation to do the following:

If the value in C3 = the value in list LIST!A1:A150, then I need the value in the cell directly right of LIST!A1:A150 (B1:B150) inserted back to the cell just right of C3 (D3)

I'm sure this is simple for you experts, but I am just a novice and I can't tell if I should be using LOOKUP, MATCH, IF, or what.

Thanks,
Gary
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Barry Katcher

Well-known Member
Joined
Feb 25, 2002
Messages
4,053
Looks like a job for Mr. VLOOKUP.
Book3
ABCD
1Barry1Geri4
2Elf2
3Gail3
4Geri4
5Stephen5
Sheet8


The syntax is: The formula first uses the first argument (C1) to look in C1. Then, it looks in the first column of the lookup range (the 2nd argument, $A$1:$B$150) to see if it finds a match. If it finds a match, it returns the value in the column of the lookup range that's indicated by the third argument (2). The last argument, FALSE, tells it to look for only exact matches.

If you click on the Function Wizard (fx) icon on your toolbar and, in the dialogue box, select the function you're interested in, a second dialogue box will give you the syntax and will walk you through entering the formula.
 

Forum statistics

Threads
1,141,018
Messages
5,703,756
Members
421,313
Latest member
Mooncake1

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?

Disable AdBlock

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

Disable AdBlock Plus

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
Top