Help! Forgot formula for copying cell value if condition is met

S

Stilla

Hi...thanks in advance for your help.
Let's say I have two tabs. The formula is going in a cell B1 in tab1.

In Tab 2, col A contains names, col B contains address, col C contains
title...etc.

I would like to manually enter one of the names in Tab 1, cell A1, and have
cell B1 automatically copy the corresponding data from say, Col B in Tab 2.
No calculations, just straight copy.

(logic would be "if the value I entered in Tab1 A1 matches any of the names
in Tab2 Col A, then copy the person's address here).

I've used it before...and it's straightforward...but this old brain just
didn't hang on to it. This was not a code or macro thing...just a straight
formula you write in a cell.

THANKS EVER SO MUCH!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help! Forgot formula for auto copy of cell value... 6
Find largest value in column with 2 criteria 1
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Return cell reference as text 1
Sum total using Sumproduct if two criteria met 5
Looking for the correct excel formula 2
Looking for a solution 1
Need help on which function to use. 1

Top