# Excel Match and Grab Formula Help

1. ## Excel Match and Grab Formula Help

I need some help with a formula, but I have no idea how to create it or what to use. Basically I have 3 columns of data, one is a list of SKUs (Column 1), another is a list of SKUs (Column 2), and the last is a list of prices (column 3).

Column 1 is by itself, and it represents items sold, so the same SKU can appear in column 1 more than once. Column 2 and 3 represent the SKU and it's cost respectively.

I would like to create a formula in a fourth column. It would be something like this: Take the value in column 1 and find that same value in column 2. Once the same value is found in column 2, give me the value to immediate right of column 2 in column 3.

I have created an example table with Column 4 representing the result I would like to have show.

Here is an example of how I would like to have it work (Looks at the table for refernce):

C1R1 is 5183. That matches with C2R2, and in C4R1 I would like the value from C3R2.
C1R2 is 4900. That matches with C2R5, and in C4R2 I would like the value from C3R5.
And so on and so on...

Column 1 Column 2 Column 3 Column 4 (Result)
Row 1 5183 720 4.03 9.87
Row 2 4900 5183 9.87 2.88
Row 3 710 5184 7.82 0.87
Row 4 710 5185 2.88
Row 5 720 4900 2.88
Row 6 4235 5190 0.27
Row 7 4275 5195 0.34
Row 8 4285 710 0.89
Row 9 4295 4235 1.45

Please let me know if I need to clarify anything.

2. ## Re: Excel Match and Grab Formula Help

Hello John, welcome to the forum.

try to use VLOOKUP. D1 then cpy down.

=VLOOKUP(A1,B:C,2,0)

3. ## Re: Excel Match and Grab Formula Help

WOW! Thanks a bunch for the help, you literally just saved me hours of work.

I just have one more question, do you know how I would make that formula link to another sheet in excel? A1 would be in the same sheet, but the B:C part would be in Sheet2 for example. My professor in college always told us it was possible, but wouldn't tell us unless we took her advanced class.

4. ## Re: Excel Match and Grab Formula Help

Nvm, just googled it. Thanks for the help Haseeb, I really appreciate it.

5. ## Re: Excel Match and Grab Formula Help

- Go to the first post
- Click edit
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1