• 414K Members
• 8,053 Online
• 478K Conversations
SOLVED

New Contributor

# Excel formula help

I have a workbook with multiple sheets. I want to basically use 2 columns worth of data from sheet 1, match it to the same data on sheet 2, and then return the value in a third column on sheet 2, in the neighbouring cell on sheet 1. I've tried many different equations without success. Can anyone help me?

5 Replies

# Re: Excel formula help

Please cite a specific example of your data and the result you need to achieve.

# Re: Excel formula help

Hi Twifoo

I've attached below the example of data that I need to create this formula for. What I need is a formula that looks at cell F2 & K2 on sheets 1, finds the exact match on sheet 2, which in this example would be line 2 on sheet 2. Then I need the formula to use the information in cell G2 on sheet 2 and put that data into cell E2 on sheet 1.

I hope I have explained this in enough detail. Thanks for your help.

Solution

# Re: Excel formula help

Hello Jason,
The formula in Sheet1!E2, copied down to Sheet1!E4 is:
=LOOKUP(PI(),
1/((Sheet2!A2:A6=--F2)*(Sheet2!H2:H6=K2)),
Sheet2!G2:G6)
F2 is left-aligned, which indicates that Excel reads it as text. The double unary (--) before F2 converts the text value of F2 to number.

# Re: Excel formula help

Perfect! Thank you so much for your time! :)

# Re: Excel formula help

Welcome, Jason!
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies