nested vlookup

I need to find on which sheet within my workbook a target value appears. The target value is a cell that contains the sum of two other cells, one a date and one a time. Target values are held in column BB of each sheet I need to know if this "number" is unique within my workbook Or if there...

Hello, Currently, have a table as below <tbody> Symbol Value Group ABCD 95 Apples CGRD 80 Oranges </tbody> Cell B2 has a formula = vlookup(a2,'\\fs\gd\[PVO Q4 2018.xlsx]Main Sheet'!$A:$Z,18,0). The A2 value can be a part of a different file link, dependent on C2. For example...

Hello. Im a bit new to the INDEX and MATCH method and I'm really not sure if thats the best way, or if VLOOKUOP is better, or something else entirely. I have a workbook with several sheets, the first is "invoice form", this is where the formula is located. The rest of the sheets coincide with a...

Hi, I'm new to the forum and hoping I'll be able to get some help with nesting vlookup arguments within a single formula. I want to look for the same lookup value (an account number) in multiple workbook sheets and return a specific value when found - the account number will only appear on one...

Hi, I have data in column L3 to L26 this is my look up value. My table array is is from A3:I112. The data in the table array is grouped by week day. Coulmn A in the table array shows the days Monday, Tuesday......etc. Column B in the table array is the same data in Column L3. What do I need...

Hi all - so I know how to use the ISNA formula with a Vlookup...BUT...I've tried and tried and can't figure out how to use it if you are using nested IF and VLookup. Here is my current formula...