|
|
#1
07-22-2015, 02:53 AM
|
|||
|
|||
Trying to get value from second sheet based on a cell
Hi,
Im not sure if vlookup is the best method or even if Im going about it incorrectly. I have 2 sheets - sheet 1 is where the data is entered and sheet 2 is where the data to select from is located (and will be hidden) I have a drop down which selects a value from sheet 2 and places it into sheet 1. What Im then trying to do is get other records relating to that selected record and populate it in a different cell - would I use a vlookup for this and if so how because when Ive tried it returns #N/A The code used is Code:
=VLOOKUP(Sheet1!Q:Q,Sheet1!B12,Sheet1!A:A,FALSE) Sheet1!B12,Sheet1!A:A is the value which relates to the value I want FALSE as I understand is it that I want an exact match? Thanks 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to Hide/Un-hide a worksheet based on cell on another sheet. | easton11 | Excel Programming | 1 | 06-02-2015 12:07 PM |
| Move data from one sheet to the next available row or cell of another sheet | bwwalker08 | Excel | 0 | 04-10-2015 11:51 AM |
 Help Coloring a cell in Sheet one if data is missing from another sheet
|
Aeducan | Excel | 1 | 06-22-2014 04:49 PM |
| Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
| copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |
Windows 7 64bit 
Office 2007
Threaded Mode