LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

Hi


"Jim May" wrote in message
news:A0JNd.55480$jn.37513@lakeread06...
Excuse Arvi, but
where you say:
On your sheet with names, enter p.e. into cell F2 the formula
=VLOOKUP(D2,References!$A$1:$B$760,2,0)
and copy it into all 13000 cells in column C

wouldn't it be:
On your sheet with names, enter p.e. into cell E2 the formula
=VLOOKUP(D2,References!$A$1:$B$760,2,0)
and copy it into all 13000 cells in column E ?


Looks like you are right. I was confused with OP's directions a bit - I
didn't realise, that she has there 2 different tables together. But it looks
like she got it anyway!

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Colors of columns after sorting data in the supporting table Booger_Boy Charts and Charting in Excel 6 January 24th 05 02:41 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Comparing data in two columns and highlighting the data David Kinsley Excel Worksheet Functions 6 January 4th 05 06:01 PM
Lookup Data in Several Columns simplywitt Excel Worksheet Functions 4 November 24th 04 04:11 PM
Comparing Data in two columns Marianne Excel Worksheet Functions 3 November 5th 04 10:26 PM


All times are GMT +1. The time now is 08:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"