vlookup

B

bob

i am trying to write a vlookup statement that will find the row of data if a
date in data sheet col c matches a date in the cell of another sheet.

if vlookup finds a matching date in data sheet col range c10:c100 that
matches a cell b5 in test sheet then
K8=IF(AND(C8="c", B8="b"),data!H11, Data!G11)

thanks
 

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

Need Help with Excel Cross Reference Formula 0
Create if partial match then copy and paste data from one cell to another 1
Copy Array to Array, how to and should I? 13
Copy row info but not in normal column sequence 6
VLookup using VB 5
transformed vloopup 2
Lookup Cell Interior 1
Eliminate blanks while copy row and transpose 11

Top