VLOOKUP??

  • Thread starter Thread starter Titanus
  • Start date Start date
T

Titanus

I have three sheets of information. In Sheet A, for cell A1, I have
to first go to Sheet B, cell B1 to find a date. From here, I need to
go to Sheet C, column A, and FIND that date, then go across that row
and return to Sheet A, cell A1, what the value found in cell AA on the
row of Sheet C for the date in question. Any help?
 
I think this is what you want to put in cell A1 on sheet 1
=VLOOKUP(Sheet2!B1,Sheet3!A1:AA10,27)
for the data on sheet 3 you will need put in the correst range for the
number of rows (ie change A1:AA10)
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
You must log in or register to reply here.

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

Vlookup and return sheet name also 2
Searching and finding 1
Excel Is this possible?? 3
Update cell value based on name and specific date 1
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
using vlookup to find data outside a specified range 1
vlookup---using data outside the range specified in the formula 4
Vlookup and Indirect 0

Back
Top