Vlookup or Hlookup

M

Mikey D

Need to know how to search a column of 1000 records to see if 20 records
exist in that column. Example Search column A for these 20 records and show
me ,else prompt not found or error not record. Saw it once but forgot how to
put in the formula
 
J

Jeff Boyce

VLookup and HLookup are Excel functions.

This newsgroup supports MS Access, the relational database.

Try an Excel 'group.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

HLOOKUP & VLOOKUP Combinded 4
Complicated Vlookup and array 1
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
Synchronization problems while moving folders to new email 1
Looking for IF with VLOOKUP statement with two conditions. 6
Recreate VLookup in MS Access 2003 Form Using DLookup..... 5
Vlookup and Hlookup 3
The Search Key was not found in any record... 0

Top