How to filter text automatically

  • Thread starter Thread starter rutima - ExcelForums.com
  • Start date Start date
R

rutima - ExcelForums.com

Hi all,
I have a workbook that has infomation imported in from
access.
the info is as shown

session date Amount Due Comments
1 1/1/05 234 11 Good
2 2/2/05 123 7 Not so Good

this goe's on for 12 sessions.
what I need is for excel to check the session on this worksheet
'Import1'
against the 'Main Sheet' cellA1 and which ever one matches then the
comment is entered into 'Main Sheet' Cell F62. hope that makes
sense.

Cheers.

Alan
 
In cell F62 of Main Sheet, put this formula............

=VLOOKUP(A1,Import1!$A$2:$E$13,5,FALSE)

Vaya con Dios,
Chuck, CABGx3
 
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

Comparing Date Ranges in one Table to Date Ranges in another Table 3
transferring data to new multiple spreadsheets 1
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Extract uniques from filtered range 3
how to add up string or text together 3
Filter/ combine data 1
Convert text to number automatically 1
VLOOK with Index - How to get results across instead of down? 3

Back
Top